pip install ydata_profiling
Requirement already satisfied: ydata_profiling in ./anaconda3/lib/python3.11/site-packages (4.6.4) Requirement already satisfied: scipy<1.12,>=1.4.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.11.1) Requirement already satisfied: pandas!=1.4.0,<3,>1.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (2.0.3) Requirement already satisfied: matplotlib<3.9,>=3.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (3.7.2) Requirement already satisfied: pydantic>=2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (2.6.1) Requirement already satisfied: PyYAML<6.1,>=5.0.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (6.0) Requirement already satisfied: jinja2<3.2,>=2.11.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (3.1.2) Requirement already satisfied: visions[type_image_path]==0.7.5 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.7.5) Requirement already satisfied: numpy<1.26,>=1.16.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.24.3) Requirement already satisfied: htmlmin==0.1.12 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.1.12) Requirement already satisfied: phik<0.13,>=0.11.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.12.4) Requirement already satisfied: requests<3,>=2.24.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (2.31.0) Requirement already satisfied: tqdm<5,>=4.48.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (4.65.0) Requirement already satisfied: seaborn<0.13,>=0.10.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.12.2) Requirement already satisfied: multimethod<2,>=1.4 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.11) Requirement already satisfied: statsmodels<1,>=0.13.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.14.0) Requirement already satisfied: typeguard<5,>=4.1.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (4.1.5) Requirement already satisfied: imagehash==4.3.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (4.3.1) Requirement already satisfied: wordcloud>=1.9.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.9.3) Requirement already satisfied: dacite>=1.8 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.8.1) Requirement already satisfied: numba<0.59.0,>=0.56.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.57.1) Requirement already satisfied: PyWavelets in ./anaconda3/lib/python3.11/site-packages (from imagehash==4.3.1->ydata_profiling) (1.4.1) Requirement already satisfied: pillow in ./anaconda3/lib/python3.11/site-packages (from imagehash==4.3.1->ydata_profiling) (9.4.0) Requirement already satisfied: attrs>=19.3.0 in ./anaconda3/lib/python3.11/site-packages (from visions[type_image_path]==0.7.5->ydata_profiling) (22.1.0) Requirement already satisfied: networkx>=2.4 in ./anaconda3/lib/python3.11/site-packages (from visions[type_image_path]==0.7.5->ydata_profiling) (3.1) Requirement already satisfied: tangled-up-in-unicode>=0.0.4 in ./anaconda3/lib/python3.11/site-packages (from visions[type_image_path]==0.7.5->ydata_profiling) (0.2.0) Requirement already satisfied: MarkupSafe>=2.0 in ./anaconda3/lib/python3.11/site-packages (from jinja2<3.2,>=2.11.1->ydata_profiling) (2.1.1) Requirement already satisfied: contourpy>=1.0.1 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (1.0.5) Requirement already satisfied: cycler>=0.10 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (0.11.0) Requirement already satisfied: fonttools>=4.22.0 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (4.25.0) Requirement already satisfied: kiwisolver>=1.0.1 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (1.4.4) Requirement already satisfied: packaging>=20.0 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (23.1) Requirement already satisfied: pyparsing<3.1,>=2.3.1 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (3.0.9) Requirement already satisfied: python-dateutil>=2.7 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (2.8.2) Requirement already satisfied: llvmlite<0.41,>=0.40.0dev0 in ./anaconda3/lib/python3.11/site-packages (from numba<0.59.0,>=0.56.0->ydata_profiling) (0.40.0) Requirement already satisfied: pytz>=2020.1 in ./anaconda3/lib/python3.11/site-packages (from pandas!=1.4.0,<3,>1.1->ydata_profiling) (2023.3.post1) Requirement already satisfied: tzdata>=2022.1 in ./anaconda3/lib/python3.11/site-packages (from pandas!=1.4.0,<3,>1.1->ydata_profiling) (2023.3) Requirement already satisfied: joblib>=0.14.1 in ./anaconda3/lib/python3.11/site-packages (from phik<0.13,>=0.11.1->ydata_profiling) (1.2.0) Requirement already satisfied: annotated-types>=0.4.0 in ./anaconda3/lib/python3.11/site-packages (from pydantic>=2->ydata_profiling) (0.6.0) Requirement already satisfied: pydantic-core==2.16.2 in ./anaconda3/lib/python3.11/site-packages (from pydantic>=2->ydata_profiling) (2.16.2) Requirement already satisfied: typing-extensions>=4.6.1 in ./anaconda3/lib/python3.11/site-packages (from pydantic>=2->ydata_profiling) (4.7.1) Requirement already satisfied: charset-normalizer<4,>=2 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (2.0.4) Requirement already satisfied: idna<4,>=2.5 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (3.4) Requirement already satisfied: urllib3<3,>=1.21.1 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (1.26.16) Requirement already satisfied: certifi>=2017.4.17 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (2023.7.22) Requirement already satisfied: patsy>=0.5.2 in ./anaconda3/lib/python3.11/site-packages (from statsmodels<1,>=0.13.2->ydata_profiling) (0.5.3) Requirement already satisfied: six in ./anaconda3/lib/python3.11/site-packages (from patsy>=0.5.2->statsmodels<1,>=0.13.2->ydata_profiling) (1.16.0) Note: you may need to restart the kernel to use updated packages.
pip install pandas
Requirement already satisfied: pandas in ./anaconda3/lib/python3.11/site-packages (2.0.3) Requirement already satisfied: python-dateutil>=2.8.2 in ./anaconda3/lib/python3.11/site-packages (from pandas) (2.8.2) Requirement already satisfied: pytz>=2020.1 in ./anaconda3/lib/python3.11/site-packages (from pandas) (2023.3.post1) Requirement already satisfied: tzdata>=2022.1 in ./anaconda3/lib/python3.11/site-packages (from pandas) (2023.3) Requirement already satisfied: numpy>=1.21.0 in ./anaconda3/lib/python3.11/site-packages (from pandas) (1.24.3) Requirement already satisfied: six>=1.5 in ./anaconda3/lib/python3.11/site-packages (from python-dateutil>=2.8.2->pandas) (1.16.0) Note: you may need to restart the kernel to use updated packages.
from ydata_profiling import ProfileReport
import pandas as pd
df = pd.read_csv('Food_Inspections_20240216.tsv',sep ='\t')
print(df)
Inspection ID DBA Name \
0 2589576 Drippin' Bites
1 2589517 GRAND BEER WINE SPIRITS
2 2589485 CASA CENTRAL COMMUNITY SERVICE
3 2589362 BARTOLI'S PIZZERIA
4 2589343 LUNCH HEROS
... ... ...
267608 197240 CINNABON
267609 114316 HARD ROCK CAFE
267610 60258 HOOK FISH & CHICKEN ON MADISON, INC.
267611 120277 POLK STREET CO.
267612 78260 DR DETON J BROOKS HEADSTART
AKA Name License # \
0 Drippin' Bites 2952306.0
1 GRAND BEER WINE SPIRITS 2923772.0
2 CASA CENTRAL COMMUNITY SERVICE 60765.0
3 BARTOLI'S PIZZERIA 2709388.0
4 LUNCH HEROS 2951905.0
... ... ...
267608 CINNABON 1846783.0
267609 HARD ROCK CAFE 51236.0
267610 HOOK FISH & CHICKEN ON MADISON, INC. 1868125.0
267611 POLK STREET CO. 29507.0
267612 DR DETON J BROOKS HEADSTART 51035.0
Facility Type Risk \
0 NaN Risk 1 (High)
1 Grocery Store Risk 3 (Low)
2 Restaurant Risk 1 (High)
3 Restaurant Risk 1 (High)
4 Restaurant Risk 1 (High)
... ... ...
267608 NaN Risk 2 (Medium)
267609 Restaurant Risk 1 (High)
267610 Restaurant Risk 2 (Medium)
267611 Restaurant Risk 1 (High)
267612 Daycare Above and Under 2 Years Risk 1 (High)
Address City State Zip Inspection Date \
0 6808 N SHERIDAN RD CHICAGO IL 60626.0 02/14/2024
1 1142 W GRAND AVE CHICAGO IL 60642.0 02/13/2024
2 1343 N CALIFORNIA AVE CHICAGO IL 60622.0 02/13/2024
3 658 N ASHLAND AVE CHICAGO IL 60622.0 02/08/2024
4 2273 N LINCOLN AVE CHICAGO IL 60614.0 02/08/2024
... ... ... ... ... ...
267608 151 N MICHIGAN AVE CHICAGO IL 60601.0 01/27/2010
267609 63 W ONTARIO ST CHICAGO IL 60654.0 02/03/2010
267610 3952 W MONROE ST CHICAGO IL 60624.0 01/14/2010
267611 548 W POLK ST CHICAGO IL 60607.0 01/06/2010
267612 6921 S STONY ISLAND AVE CHICAGO IL 60649.0 01/15/2010
Inspection Type Results \
0 License Not Ready
1 License Pass
2 Canvass Pass
3 Canvass Fail
4 License Not Ready
... ... ...
267608 Out of Business Fail
267609 Canvass Pass w/ Conditions
267610 Complaint Re-Inspection Pass
267611 Canvass Fail
267612 Canvass Pass
Violations Latitude \
0 NaN 42.005827
1 NaN 41.891202
2 NaN 41.905986
3 48. WAREWASHING FACILITIES: INSTALLED, MAINTAI... 41.894209
4 NaN 41.923574
... ... ...
267608 NaN 41.884540
267609 21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTE... 41.893128
267610 NaN 41.879875
267611 18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN... 41.872113
267612 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO... 41.769129
Longitude Location
0 -87.661140 (42.00582694496218, -87.66114012527682)
1 -87.656295 (41.89120176033192, -87.6562947219871)
2 -87.696807 (41.90598597077873, -87.69680735572291)
3 -87.667382 (41.894208809612294, -87.66738222845791)
4 -87.645932 (41.9235739992025, -87.64593222667874)
... ... ...
267608 -87.624309 (41.88454011059238, -87.62430852246028)
267609 -87.630563 (41.89312775453658, -87.63056251830054)
267610 -87.725290 (41.8798749138472, -87.7252903599048)
267611 -87.641305 (41.87211261426958, -87.64130525460628)
267612 -87.585827 (41.76912914412988, -87.58582746167004)
[267613 rows x 17 columns]
profile = ProfileReport(df,title = 'Food_Inspections_Report' )
profile.to_notebook_iframe()
Summarize dataset: 0%| | 0/5 [00:00<?, ?it/s]
Generate report structure: 0%| | 0/1 [00:00<?, ?it/s]
Render HTML: 0%| | 0/1 [00:00<?, ?it/s]